describeINSERT INTO test VALUE kunde; 
DROP TABLE test;
CREATE TABLE test(
id INTEGER Primary key, 
begruessung CHAR(20)
); 
describe test;
INSERT INTO test VALUES (1, 'Hallo ');
SELECT * FROM test;1
S (2, 'Du da ');
SELECT * FROM test;
UPDATE test 
SET begruessung = 'Sehr geehrte'
WHERE Id=2;
Select * from test;
ALTER TABLE test 
modify begruessung CHAR(30);
describe test;
UPDATE test 
SET begruessung = 'Sehr geehrte Damen und Herren'
WHERE Id=2;
SELECT * FROM test;
DELETE FROM test 
WHERE Id=1;
SELECT * FROM test;
-- -----------------------------------
DROP TABLE test;
CREATE TABLE test(
id INTEGER Primary key, 
begruessung CHAR(20)  NOT NULL
); 
INSERT INTO test (id) VALUES (1);
INSERT INTO test (id, begruessung) VALUES (1, NULL);
INSERT INTO test VALUES (1, NULL);
INSERT INTO test ( begruessung, id) VALUES ('hallo', 1);
select * from test
